﻿CREATE TABLE [ccc].[CarbonCalc] (
    [Id]                  INT            IDENTITY (1, 1) NOT NULL,
    [UserId]              INT            NOT NULL,
    [CreatedDateTime]     DATETIME       NOT NULL,
    [LastUpdated]         DATETIME       NOT NULL,
    [Audit]               INT            NOT NULL,
    [NoPupils]            INT            NOT NULL,
    [KWH]                 INT            NULL,
    [WasteAuditCompleted] BIT            NOT NULL,
    [LandPaper]           DECIMAL (9, 3) NULL,
    [LandCard]            DECIMAL (9, 3) NULL,
    [LandFood]            DECIMAL (9, 3) NULL,
    [LandBottles]         DECIMAL (9, 3) NULL,
    [LandPackaging]       DECIMAL (9, 3) NULL,
    [LandCans]            DECIMAL (9, 3) NULL,
    [LandGlass]           DECIMAL (9, 3) NULL,
    [LandOther]           DECIMAL (9, 3) NULL,
    [RecylePaper]         DECIMAL (9, 3) NULL,
    [RecyleCard]          DECIMAL (9, 3) NULL,
    [RecyleFood]          DECIMAL (9, 3) NULL,
    [RecyleBottles]       DECIMAL (9, 3) NULL,
    [RecylePackaging]     DECIMAL (9, 3) NULL,
    [RecyleCans]          DECIMAL (9, 3) NULL,
    [RecyleGlass]         DECIMAL (9, 3) NULL,
    [RecyleOther]         DECIMAL (9, 3) NULL,
    [ConcurencyId]        TIMESTAMP      NOT NULL
);

